from utils.file_handling.excel_handling import ExcelUtil

print("开始")
filename = r"C:\Users\Mr.Yan\Downloads\大区数据模板 (1).xlsx"

list = []

a = ExcelUtil(filename).read_excel()
# print(a)
# for i in a:
#     dict1 = {
#         "dimissionId": "",
#         "newAssistantId": "",
#         "doctorId": ""
#     }
#     dict1['dimissionId'] = i['老医助ID']
#     dict1['newAssistantId'] =i['新医助ID']
#     dict1['doctorId'] =i['医生ID']
#
#     list.append(dict1)

print(list)
print(len(list))

# url = r'https://wt.zenggao.net/admin/parasol/public/api/assistant/dimission/bind/new/assistant'
# num=0
# for lis in list:
#     result = requests.get(url=url, params=lis)
#     print(result)
#     num=num+1
#     sleep(0.5)
#
# print('共执行条数：',num)